 
 <#-- 
 
 muestra la estructura
 para todas las tablas de una base de datos...
 
 
 -->
<#-- variables used internally by the generator... -->
<#assign nameFile="aspx">
<#assign extensionFile="aspx">
<#assign languageGenerated="c#">
<#assign description="c#">
<#assign targetDirectory="detail">
<#assign appliesToAllTables="true">
<#-- END variables used internally by the generator... -->


#
# Database structure for database '${project}'
#

CREATE DATABASE /*!32312 IF NOT EXISTS*/ "${project}" /*!40100 DEFAULT CHARACTER SET latin1 */;

USE "${project}";


<#list project.getTables() as tablita>
 
#
# Table structure for table '${tablita}'
#


CREATE TABLE /*!32312 IF NOT EXISTS*/ "${tablita}" (
 
	<#list tablita.getFields() as field>
	 
		 <#-- segun el tipo de campo...   -->
		 <#switch field.getType()>
			  <#case "_int">
			     "${field}" int(${field.getSize()}) unsigned NOT NULL 
				 
				<#break>
			  <#case "_string">
			     "${field}" varchar(${field.getSize()}) NOT NULL default '',
			     <#break>
			  <#case "_date">
			     "${field}" datetime NOT NULL default '0000-00-00 00:00:00',
			     <#break>
			  <<#case "_boolean">
			     "${field}" tinyint(1) NOT NULL default '0',
			     <#break>
			  <#default>
			     "${field}" varchar(${field.getSize()}) NOT NULL default '',
		</#switch>  
	</#list>		
	PRIMARY KEY  (${table.getListOnlyKeyFields()}),
	# KEY "catid" ("catid","published","archived")
);


#
# Dumping data for table '#__weblinks'
#

# No data found.



</#list>


